Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
OBJ VARCHAR2(20) Yes null 1 null NO NO NO
ID VARCHAR2(100) Yes null 2 null NO NO NO
OBJ_TYPE VARCHAR2(100) Yes null 3 null NO NO NO
DISPOSITION VARCHAR2(4000) Yes null 4 null NO NO NO
LEAD VARCHAR2(400) Yes null 5 null NO NO NO
LEAD_OBJ VARCHAR2(20) Yes null 6 null NO NO NO
STATUS VARCHAR2(100) Yes null 7 null NO NO NO
SUPPORT_PERSONNEL VARCHAR2(400) Yes null 8 null NO NO NO
SUPPORT_PERS_OBJ VARCHAR2(20) Yes null 9 null NO NO NO
CREATED_ON DATE Yes null 10 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_INTAKE_ASSOC_FILES VIEW QART V_ALL_FILES_INTAKE_ASSOC VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART V_SIIC_THREAT_INV VIEW
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART MV_ACM_OBJ TABLE
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART V_CURR_OBJ_LEAD_PERS VIEW
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART V_OBJ_STATUS_HISTORY VIEW
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART MV_F_INFORMATION_REF TABLE
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART V_CURR_OBJ_SUPPORT_OFFICER VIEW
NAME VALUE
CREATED 23-OCT-24
LAST_DDL_TIME 24-OCT-24
OWNER QART
VIEW_NAME V_ALL_FILES_INTAKE_ASSOC
TEXT_LENGTH 1309
TEXT SELECT OBJ, ID, OBJ_TYPE, DISPOSITION, LEAD, LEAD_OBJ, STATUS, SUPPORT_PERSONNEL, SUPPORT_PERS_OBJ, CREATED_ON FROM ( --Informational Investigation Select i.obj, i.ID, ot.display OBJ_TYPE, ir.display DISPOSITION, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, o.CREATED_ON from mv_f_information i inner join      mv_acm_obj o on i.obj = o.sid inner join  mv_acm_obj_type ot on o.obj_type = ot.sid left outer join  v_curr_obj_lead_pers lp on i.obj = lp.obj inner join  v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join  mv_f_information_ref ir on i.disposition = ir.ref_key left outer join  v_curr_obj_support_officer so on i.obj = so.obj UNION ALL --Threat Investigation select i.obj, i.id, ot.display OBJ_TYPE, i.final_disposition Disposition, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, i.CREATED_DATE from v_siic_threat_inv i inner join      mv_acm_obj o on i.obj = o.sid inner join  mv_acm_obj_type ot on o.obj_type = ot.sid left outer join  v_curr_obj_lead_pers lp on i.obj = lp.obj inner join  v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join      v_curr_obj_support_officer so on i.obj = so.obj )
TEXT_VC SELECT OBJ, ID, OBJ_TYPE, DISPOSITION, LEAD, LEAD_OBJ, STATUS, SUPPORT_PERSONNEL, SUPPORT_PERS_OBJ, CREATED_ON FROM ( --Informational Investigation Select i.obj, i.ID, ot.display OBJ_TYPE, ir.display DISPOSITION, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, o.CREATED_ON from mv_f_information i inner join      mv_acm_obj o on i.obj = o.sid inner join  mv_acm_obj_type ot on o.obj_type = ot.sid left outer join  v_curr_obj_lead_pers lp on i.obj = lp.obj inner join  v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join  mv_f_information_ref ir on i.disposition = ir.ref_key left outer join  v_curr_obj_support_officer so on i.obj = so.obj UNION ALL --Threat Investigation select i.obj, i.id, ot.display OBJ_TYPE, i.final_disposition Disposition, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, i.CREATED_DATE from v_siic_threat_inv i inner join      mv_acm_obj o on i.obj = o.sid inner join  mv_acm_obj_type ot on o.obj_type = ot.sid left outer join  v_curr_obj_lead_pers lp on i.obj = lp.obj inner join  v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join      v_curr_obj_support_officer so on i.obj = so.obj )
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT